AP_AuditTrailEntry Data Dictionary

Detailed descriptions of the audit trail entry fields in an Electronic Health Record system

Original Column Name Expanded Column Name Description
AuditTrailEntryID Audit Trail Entry Details Unique identifier for each entry in the audit trail documenting changes or actions performed within the system.
AuditLogID Audit Log Details Reference to the specific audit log record that this entry belongs to, indicating the broader context of the audit event.
PKID PKID Primary Key ID; the unique identifier for the primary key of the record that was affected by the event being audited.
PKName PKName Primary Key Name; the name of the primary key column of the record that was affected in the auditing event.
RecName Rec Name Record Name; the human-readable name or description of the record that was accessed or modified.
TableName Table Name The name of the database table that contains the record being audited, which indicates where the event occurred within the system's data structure.
TypeID Type Details Type ID; an identifier that classifies the type of event that was audited, such as creation, modification, deletion, or access.
ZUChkSum ZU Check Sum Zero Usage Check Sum; a cryptographic checksum used to verify the integrity of the data associated with the audit record for security and data corruption detection purposes.
ZUDate ZU Date Zero Usage Date; the date and time when the audit entry was recorded or processed, used for tracking and historical analysis.
ZULogonHisID ZU Logon History Details Zero Usage Logon History ID; refers to the identifier of the user's logon session that is related to the audit event, providing a linkage to the user who initiated the change.